﻿CREATE TABLE [dbo].[ProjectExpenditure] (
    [Id]                   INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [PEId]                 UNIQUEIDENTIFIER NULL,
    [ProjectName]          NVARCHAR (50)    NULL,
    [DepartmentId]         INT              NULL,
    [UserName]             NVARCHAR (50)    NULL,
    [Content]              VARCHAR (MAX)    NULL,
    [ApplyAmount]          NUMERIC (18)     NULL,
    [SubjectId]            INT              NULL,
    [LaunchDate]           DATETIME         NULL,
    [ManagerApprove]       BIT              NULL,
    [ManagerApprovePerson] NVARCHAR (50)    NULL,
    [ManagerApproveDate]   DATETIME         NULL,
    [FinanceApprove]       BIT              NULL,
    [FinanceApprovePerson] NVARCHAR (50)    NULL,
    [FinanceApproveDate]   DATETIME         NULL,
    [Description]          VARCHAR (MAX)    NULL,
    [CompanyId]            INT              NULL,
    CONSTRAINT [PK_ProjectExpenditure] PRIMARY KEY CLUSTERED ([Id] ASC)
);

